﻿CREATE TABLE [dbo].[ListaOperatiuni] (
    [IDOperatiune]     INT             IDENTITY (1, 1) NOT NULL,
    [Data]             DATETIME        NOT NULL,
    [Numar]            DECIMAL (20)    CONSTRAINT [DF__ListaOper__Numar__0CA6A535] DEFAULT ((0)) NOT NULL,
    [Explicatii]       VARCHAR (200)   NOT NULL,
    [ValoareLei]       DECIMAL (20, 2) CONSTRAINT [DF__ListaOper__Valoa__0D9AC96E] DEFAULT ((0)) NOT NULL,
    [ContDebit]        VARCHAR (50)    NOT NULL,
    [ContCredit]       VARCHAR (50)    NOT NULL,
    [CrediteAprobate]  DECIMAL (20, 2) CONSTRAINT [DF__ListaOper__Credi__0E8EEDA7] DEFAULT ((0)) NOT NULL,
    [CrediteDeschise]  DECIMAL (20, 2) CONSTRAINT [DF__ListaOper__Credi__0F8311E0] DEFAULT ((0)) NOT NULL,
    [Plati]            DECIMAL (20, 2) CONSTRAINT [DF__ListaOper__Plati__10773619] DEFAULT ((0)) NOT NULL,
    [Restituiri]       DECIMAL (20, 2) CONSTRAINT [DF__ListaOper__Resti__116B5A52] DEFAULT ((0)) NOT NULL,
    [CheltuieliDebit]  DECIMAL (20, 2) CONSTRAINT [DF__ListaOper__Chelt__125F7E8B] DEFAULT ((0)) NOT NULL,
    [CheltuieliCredit] DECIMAL (20, 2) CONSTRAINT [DF__ListaOper__Chelt__1353A2C4] DEFAULT ((0)) NOT NULL,
    CONSTRAINT [PK_ListaOperatiuni] PRIMARY KEY CLUSTERED ([IDOperatiune] ASC)
);

